Table 3: OpenEdge SQL system limits
|
Attribute
|
Name
|
Value
|
|
Maximum number of open cursors.
|
OPEN_CURSORS
|
50
|
|
Maximum number of procedure arguments in an SQL CALL statement.
|
TPE_MAX_PROC_ARGS
|
50
|
|
Maximum length of an SQL statement.
|
TPE_MAX_SQLSTMTLEN
|
131000
|
|
Maximum length of a column in a table.
|
TPE_MAX_FLDLEN
|
31995
|
|
Maximum length of default value specification.
|
TPE_MAX_DFLT_LEN
|
250
|
|
Maximum length of a connect string.
|
TPE_MAX_CONNLEN
|
100
|
|
Maximum length for a table name.
|
TPE_MAX_IDLEN
|
32
|
|
Maximum length for an area name.
|
TPE_MAX_AREA_NAME
|
32
|
|
Maximum length for a username in a connect string.
|
TPE_UNAME_LEN
|
32
|
|
Maximum length of an error message.
|
TPE_MAX_ERRLEN
|
256
|
|
Maximum number of columns in a table.
|
TPE_MAX_FIELDS
|
500
|
|
Maximum length of a CHECK constraint clause.
|
SQL_MAXCHKCL_SZ
|
240
|
|
Maximum number of nesting levels in an SQL statement.
|
SQL_MAXLEVELS
|
25
|
|
Maximum number of table references in an SQL statement: other platforms.
|
SQL_MAXTBLREF
|
250
|
|
Maximum size of input parameters for an SQL statement.
|
SQL_MAXIPARAMS_SZ
|
512
|
|
Maximum number of outer references in an SQL statement.
|
SQL_MAX_OUTER_REF
|
25
|
|
Maximum nesting level for view references.
|
MAX_VIEW_LEVEL
|
25
|
|
Maximum number of check constraints in a table.
|
SQL_MAXCHKCNSTRS
|
1000 total constraints per table
|
|
Maximum number of foreign constraints in a table.
|
SQL_MAXFRNCNSTRS
|
1000 total constraints per table
|
|
Maximum LOB length.
|
SQL_MAXLOB
|
1 GB
|